select * from products where pro_name like '%all%dresses%' or pro_des like '%all%dresses%'union all select * from products where (pro_name like '%all%' or pro_des like '%all%') or(pro_name like '%dresses%' or pro_des like '%dresses%') and (pro_name not like '%all%dresses%' or pro_des not like '%all%dresses%')
Hot Pink Pick-ups Sweet Sixteen Dresses with Beading and Ruches
Multi-colored Pick-ups and Ruffles Dresses for a Quince Hot Sale
berlin film festival 2014 Two-toned Strapless Beading Quinceanera Dresses in Organza
Colorful Off the Shoulder Appliques Quinceanera Gown in Organza
Red Ball Gown Strapless Appliques Dresses for a Quinceanera 2014
Gorgeous Beaded Rust Red Dress for Quince with Rolling Flowers
Leopard Printing Strapless Dress for Quince in Taffeta and Organza
Pink Ball Gown Beading Tulle Dresses for a Quinceanera Wholesale
Modest Ball Gown Appliques Strapless Sweet 15 Dresses in Taffeta
Purple Ball Gown Ruched Appliques Quince Dresses with Pick-ups
Trendy Organza Yellow Dresses for Quince with Beading Appliques
Dark Purple Embroidery Dress Quinceanera in Taffeta and Organza
Embroidery Strapless Navy Blue Sweet 15 Dresses Custom Made
Wine Red Pick-ups Embroidery Quinceanera Party Dress in Fashion
Halter Top Appliques Beaded Pick-ups Quince Dress in Navy Blue
Dark Green Halter Top Pick-ups Dresses for a Quince with Beading
Cheap Sweetheart Spring Green Sweet Sixteen Dress with Appliques
Lavender Sweetheart Ball Gown Appliques Quinceanera Dresses
Orange Red Ball Gown Sweetheart Appliques Sweet 16 Dresses
Ball Gown Strapless Taffeta Ruched Lace Accent Sweet 15 Dresses
Lilac Ball Gown Sweetheart Beading Pleated Sweet Sixteen Dresses
Popular Hot Pink Ball Gown Sweetheart Ruffled Sweet 15 Dresses
Red Beading Ball Gown Strapless Pleated Quinceanera Dresses Plus
Blue Ball Gown Strapless Leopard Pick-ups Quinceanera Dresses
Strapless Lavender Organza Ruffles Ball Gown Sweet Sixteen Dresses
Multi-colored Ball Gown Ruffled Beading Strapless Quince Dresses
Green Tulle Floor-length Ball Gown Sweet Sixteen Dresses
Purple Ball Gown Taffeta and Tulle Quinceanera Dresses
Ball Gown Organza Quinceanera Dresses with Ruffles and Beading
Lavender Organza Ruched Dress for Quinceaneras with Appliques